Live freelance tracking. Raw descriptions turned into structured data. Find your next tech project without the noise.
upwork.com 🟡 2026-05-28
🔹 NSW Council DA Lead Generation System
👤 Client: 🇦🇺 Australia Member since 2026-03-27
💰 Price: ****
🚩 Problem: Manual extraction of high-intent residential construction leads from fragmented local government planning portals to identify decision-makers.
📦 Existing: NSW Planning Portal, Individual Council DA search tools, Google Sheets
Specifications:
[Target] Residential projects: Two-storey houses, Duplexes, Townhouses, Multi-dwelling, New builds
[Target] Regions: Central Coast, Newcastle, Lake Macquarie, Maitland, Cessnock, Port Stephens, Mid-Coast, Singleton
[Method] DA Portal scraping, Construction Certificate (CC) document analysis, LinkedIn/Company website verification
[UI/UX] Shared Google Sheet with strict column formatting (no merged cells)
[Stack] Google Sheets
[Security] Direct personal contact data (Decision Makers only); exclusion of generic emails (info@, admin@)
[Format] Fields: Council Name, DA Number, Address, Description, Approval Date, CC Status, Estimated Value, Developer Details (Name, Decision Maker, Direct Email, Mobile, Address), Builder Details (Name, Decision Maker, Direct Email, Mobile, Address)
Workflow:
1. Monitor NSW Planning Portal and local council DA tools for approvals within the last 6 months.
2. Filter for qualifying residential project types and CC issuance status.
3. Extract developer and builder entities from DA applications and attached CC documents.
4. Research and verify direct decision-maker contact details via company websites and LinkedIn.
5. Deduplicate and populate structured Google Sheet.
6. Flag high-priority leads with verified personal contact information.